/*
Navicat SQL Server Data Transfer

Source Server         : 本地sqlServer
Source Server Version : 105000
Source Host           : 127.0.0.1:1433
Source Database       : newhis
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 105000
File Encoding         : 65001

Date: 2020-11-15 10:47:37
*/


-- ----------------------------
-- Table structure for ZZ_XNYS
-- ----------------------------
DROP TABLE [dbo].[ZZ_XNYS]
GO
CREATE TABLE [dbo].[ZZ_XNYS] (
[ysid] varchar(20) NOT NULL ,
[ysxm] varchar(50) NULL ,
[ksid] varchar(20) NULL ,
[ksid2] varchar(20) NULL ,
[ksmc] varchar(50) NULL ,
[ysdm] varchar(20) NULL ,
[ghf] numeric(10,2) NULL ,
[zlf] numeric(10,2) NULL ,
[ghlb] varchar(20) NULL ,
[professional] varchar(200) NULL ,
[introduce] varchar(50) NULL ,
[doctorPic] varchar(50) NULL ,
[deptAddr] varchar(200) NULL
)


GO
IF ((SELECT COUNT(*) from fn_listextendedproperty('MS_Description',
'SCHEMA', N'dbo',
'TABLE', N'ZZ_XNYS',
NULL, NULL)) > 0)
EXEC sp_updateextendedproperty @name = N'MS_Description', @value = N'虚拟医生'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZZ_XNYS'
ELSE
EXEC sp_addextendedproperty @name = N'MS_Description', @value = N'虚拟医生'
, @level0type = 'SCHEMA', @level0name = N'dbo'
, @level1type = 'TABLE', @level1name = N'ZZ_XNYS'
GO

-- ----------------------------
-- Records of ZZ_XNYS
-- ----------------------------
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'XN001', N'内科(感染性疾病科)普通', N'143', N'2', N'内科(感染性疾病科)普通门诊', null, null, null, N'普通', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'XN002', N'呼吸内科(结核)普通', N'127', N'5', N'呼吸内科(结核)普通门诊', null, null, null, N'普通', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'XN004', N'妇产科', N'10', N'3', N'妇产科门诊', null, null, null, N'普通', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'XN008', N'发热门诊', N'114', N'16', N'发热门诊', null, null, null, N'普通', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'ZJ003', N'中西医结合科专家', N'144', N'11', N'中西医结合科专家门诊', null, null, null, N'专家号', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'ZJ005', N'呼吸内科(结核)专家', N'142', N'1', N'呼吸内科(结核)专家门诊', null, null, null, N'专家号', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'ZJ006', N'妇产科专家', N'10', N'31', N'妇产科专家门诊', null, null, null, N'专家号', N'主治医师', N'医生简介', null, null)
GO
GO
INSERT INTO [dbo].[ZZ_XNYS] ([ysid], [ysxm], [ksid], [ksid2], [ksmc], [ysdm], [ghf], [zlf], [ghlb], [professional], [introduce], [doctorPic], [deptAddr]) VALUES (N'ZJ007', N'内科(感染性疾病科)专家', N'9', N'6', N'内科(感染性疾病科)专家门诊', null, null, null, N'专家号', N'主治医师', N'医生简介', null, null)
GO
GO

-- ----------------------------
-- Indexes structure for table ZZ_XNYS
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table ZZ_XNYS
-- ----------------------------
ALTER TABLE [dbo].[ZZ_XNYS] ADD PRIMARY KEY ([ysid])
GO
